package com.cspg.ssss.repository;

import com.cspg.ssss.domain.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

@Mapper
public interface ScoreStatisticsMapper {

    List<ScoreVO> selectScoreStatisticsList(Map<String, Object> map);

    List<ScoreSelectVO> selectGsSubScoreList(Map<String, Object> map);

    List<ScoreSelectVO> selectDwSubScoreList(Map<String, Object> map);

    List<ScoreSelectVO> selectAddScoreList(Map<String, Object> map);

    int insertScoreStatistics(ScoreVO vo);

    int selectScoreStatisticsById(String id);

    int updateScoreStatistics(ScoreVO vo);

    List<DwdgbmGradeViewEntity> selectDwGradeList(Map<String, Object> map);

    List<GsdgdwGradeViewEntity> selectGsGradeList(Map<String, Object> map);

    List<ScoreAddApplyEntity> selectAddGradeList(Map<String, Object> map);

    List<String> scoreGsDeptList(Map<String, Object> map);

    List<String> scoreDwDeptList(Map<String, Object> map);

    List<String> scoreAddDeptList(Map<String, Object> map);

    List<ScoreDetailedTotalVO> selectDetailedTotalList(Map<String, Object> map);

    List<ScoreDetailedTotalVO> selectAddDetailedTotalList(Map<String, Object> map);
}
